﻿CREATE TABLE [dbo].[NSI_ORGANIZATION] (
    [ID]               INT            IDENTITY (1, 1) NOT NULL,
    [SHORT_NAME]       NVARCHAR (255) NOT NULL,
    [FULL_NAME]        NVARCHAR (255) NULL,
    [INN]              NVARCHAR (255) NULL,
    [KPP]              NVARCHAR (255) NULL,
    [OKPO]             NVARCHAR (255) NULL,
    [FULL_ADDR]        NVARCHAR (255) NULL,
    [ADDR_1]           NVARCHAR (255) NULL,
    [ADDR_2]           NVARCHAR (255) NULL,
    [ADDR_3]           NVARCHAR (255) NULL,
    [ADDR_4]           NVARCHAR (255) NULL,
    [COUNTRY]          NVARCHAR (255) NULL,
    [CITY]             NVARCHAR (255) NULL,
    [POST_INDEX]       NVARCHAR (255) NULL,
    [CONTACT]          NVARCHAR (255) NULL,
    [PHONE]            NVARCHAR (255) NULL,
    [FAX]              NVARCHAR (255) NULL,
    [LAST_UPDATE]      DATETIME2 (7)  NULL,
    [LAST_UPDATE_USER] NVARCHAR (50)  NULL
);





